package com.koron.css2.newProjectCenter.function.oracleMapper;

import com.koron.css2.newProjectCenter.bean.CreateAccountBean;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

@Mapper
public interface OracleMapper {
    @Select("SELECT RIM_PKG_INTERFACE_CUSTOMERS.PKG_CHG_ACCOUNTS(null, #{businessCode} , #{areaCode} , null, 1) from dual")
    String getUserCode(@Param("businessCode") String businessCode, @Param("areaCode") Integer areaCode);

    Integer callCreateFunction(CreateAccountBean bean);

    Integer getUserId(String userNo);

    String testFunc();
}
